Skip Headers

Oracle® Database Extensions for .NET Developer's Guide 10g Release 2 (10.2) Part Number B14306-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# 2 Installation and Configuration

This chapter describes the installation of Oracle Database Extensions for .NET, system requirements, and file locations.

This chapter contains these topics:

- System Requirements

- Requirements for .NET Stored Procedures and Functions

- File Locations after Installation

- Installation and First Use

- Configuring Extproc Agent Using Windows Service

## System Requirements

Oracle Database Extensions for .NET requires the following:

- Microsoft .NET Framework 1.0 or later.

- Microsoft Windows 2003, Windows 2000, or Windows XP.

- Oracle Database 10g Release 2 (10.2) or later.

- Oracle Client release 10g Release 2 (10.2) or later is required for .NET stored procedure development and deployment.

- Oracle Developer Tools for Visual Studio .NET.

  Oracle Developer Tools for Visual Studio .NET is not released with Oracle Database 10g Release 2 (10.2). It can be obtained from the Oracle .NET Developer Center at OTN.

## Requirements for .NET Stored Procedures and Functions

A .NET stored procedure or function must meet the following requirements:

- Be declared a public static method.

- Not be a constructor or a destructor.

- Use parameter types that are compatible with the Oracle native database types.

## File Locations after Installation

`OraClr10.dll` is installed in the `ORACLE_BASE\ORACLE_HOME`\`bin` directory.The `readme.txt` file is installed in the `ORACLE_BASE\ORACLE_HOME``\ODE` directory.

.NET assemblies deployed by developers are copied into the `ORACLE_BASE``\``ORACLE_HOME``\``bin\CLR` directory (or its subdirectory) by the Oracle Deployment Wizard for .NET.

## Installation and First Use

Oracle Database Extensions for .NET is installed as part of a custom Oracle Database installation using the Oracle Universal Installer. From the Oracle Universal Installer Welcome screen, you must chose Advanced Installation, then from the Select Installation Type screen, choose Custom. When the Available Product Components list is displayed, go to Enterprise Edition Options, and select Oracle Database Extensions for .NET.

Oracle Database Extensions for .NET is configured using the Database Configuration Assistant.

## Configuring Extproc Agent Using Windows Service

As part of Oracle Database Extensions for .NET installation, a Windows service is installed. The service is called `OraClrAgnt` and can be accessed through the Service Control Panel, as `Oracle` `OracleHomeName` `ClrAgnt`, where `OracleHomeName` represents your Oracle home.

This service is used for the startup, configuration, and shutdown of the `extproc` agent.

The parameters which can be configured using this service are listed in Table 2-1, "OraClrAgnt Service Parameters".

These parameter values can be specified as part of the Start Parameters in the properties window of the Control Panel Service. In this case, the parameter values are not saved and the values must be supplied again if the service is restarted later.

To persist the parameter values, you can change the service registry entry and provide the parameter values as command line parameters to `OraClrAgnt.exe`, for example:

`ORACLE_BASE\ORACLE_HOME``\bin\oraclragnt.exe agent_sid=CLRExtProc max_task_threads=5`

This sets the number of maximum task threads to `5` while other optional parameters like `max_dispatchers`, `tcp_dispatchers` and `max_sessions` are set to their default values.

If the service cannot be started or stopped, the error messages are logged in the Application Log of the Event Viewer, with the service name as the event source name.

### OraClrAgnt Service Parameters

Table 2-1 lists the parameters which can be configured using this service.

Table 2-1 OraClrAgnt Service Parameters

Parameters | Descriptions
--- | ---
`agent_sid` | This represents the `SID` of the `extproc` process with a default value of `CLRExtProc`. This is a mandatory parameter. If this parameter value is changed, appropriate changes need to be made in `tnsnames.ora` and `listener.ora` files.
`listener_address` | Address on which the listener is listening. This is an optional parameter. If it is not specified, then this is set to the default value.
`max_dispatchers` | Number of maximum dispatchers in the `extproc` process. This is an optional parameter. If it is not specified, then this number is set to a default value.
`max_sessions` | Number of maximum sessions in the `extproc` process. This is an optional parameter. If it is not specified, then this number is set to a default value.
`max_task_threads` | Number of maximum task threads in the `extproc` process. This is an optional parameter. If it is not specified, then this number is set to a default value.
`shutdown_address` | Address on which the agent should listen for shutdown messages from `agtctl`. This is an optional parameter. If it is not specified, then this is set to the default value.
`tcp_dispatchers` | Number of TCP dispatchers in the `extproc` process. This is an optional parameter. If it is not specified, then this number is set to a default value.

Note: By default, this service is created and run in the Local System Account; however, it can be changed to work with a logged-on user account through the service control panel.

See Also: Oracle Database Heterogeneous Connectivity Administrator's Guide, Table 5-2, for further information about configuration parameters